Dataset statistics
| Number of variables | 25 |
|---|---|
| Number of observations | 31734 |
| Missing cells | 2 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 6.1 MiB |
| Average record size in memory | 200.0 B |
Variable types
| DateTime | 2 |
|---|---|
| Numeric | 14 |
| Categorical | 9 |
Tipo Cliente has constant value "Ualet puro" | Constant |
cant has constant value "1" | Constant |
Primer Nombre has a high cardinality: 3187 distinct values | High cardinality |
Ciudad has a high cardinality: 844 distinct values | High cardinality |
Id Modificado is highly correlated with Cod. Ocupacion | High correlation |
Cod_Ciudad_Nac. is highly correlated with Cod Dpto.Nacimto. | High correlation |
Cod Dpto.Nacimto. is highly correlated with Cod_Ciudad_Nac. | High correlation |
Cod. Ocupacion is highly correlated with Id Modificado | High correlation |
Ingresos_mensuales is highly correlated with Otros_Ing_Mensuales and 1 other fields | High correlation |
Otros_Ing_Mensuales is highly correlated with Ingresos_mensuales and 1 other fields | High correlation |
Total_Activos is highly correlated with Ingresos_mensuales and 1 other fields | High correlation |
Transacciones is highly correlated with Transacciones Adiciones and 1 other fields | High correlation |
Transacciones Adiciones is highly correlated with Transacciones and 1 other fields | High correlation |
Transacciones Retiros is highly correlated with Transacciones and 1 other fields | High correlation |
Id Modificado is highly correlated with Codigo CIIU and 5 other fields | High correlation |
Codigo CIIU is highly correlated with Id Modificado and 6 other fields | High correlation |
Cod_Ciudad_Nac. is highly correlated with Cod Dpto.Nacimto. | High correlation |
Cod Dpto.Nacimto. is highly correlated with Cod_Ciudad_Nac. | High correlation |
Cod. Ocupacion is highly correlated with Id Modificado and 6 other fields | High correlation |
Ingresos_mensuales is highly correlated with Id Modificado and 6 other fields | High correlation |
Egresos_mensuales is highly correlated with Id Modificado and 6 other fields | High correlation |
Otros_Ing_Mensuales is highly correlated with Codigo CIIU and 5 other fields | High correlation |
Total_Activos is highly correlated with Id Modificado and 6 other fields | High correlation |
Total_Pasivos is highly correlated with Id Modificado and 6 other fields | High correlation |
Saldo is highly correlated with Transacciones Adiciones | High correlation |
Transacciones is highly correlated with Transacciones Adiciones and 1 other fields | High correlation |
Transacciones Adiciones is highly correlated with Saldo and 2 other fields | High correlation |
Transacciones Retiros is highly correlated with Transacciones and 1 other fields | High correlation |
Id Modificado is highly correlated with Codigo CIIU and 4 other fields | High correlation |
Codigo CIIU is highly correlated with Id Modificado and 6 other fields | High correlation |
Cod_Ciudad_Nac. is highly correlated with Cod Dpto.Nacimto. | High correlation |
Cod Dpto.Nacimto. is highly correlated with Cod_Ciudad_Nac. | High correlation |
Cod. Ocupacion is highly correlated with Id Modificado and 5 other fields | High correlation |
Ingresos_mensuales is highly correlated with Id Modificado and 5 other fields | High correlation |
Egresos_mensuales is highly correlated with Id Modificado and 5 other fields | High correlation |
Otros_Ing_Mensuales is highly correlated with Codigo CIIU and 1 other fields | High correlation |
Total_Activos is highly correlated with Id Modificado and 5 other fields | High correlation |
Total_Pasivos is highly correlated with Codigo CIIU and 5 other fields | High correlation |
Transacciones is highly correlated with Transacciones Adiciones and 1 other fields | High correlation |
Transacciones Adiciones is highly correlated with Transacciones and 1 other fields | High correlation |
Transacciones Retiros is highly correlated with Transacciones and 1 other fields | High correlation |
Riesgo is highly correlated with Id Modificado and 1 other fields | High correlation |
Transacciones Retiros is highly correlated with Transacciones Adiciones and 1 other fields | High correlation |
Otros_Ing_Mensuales is highly correlated with Ingresos_mensuales and 1 other fields | High correlation |
Id Modificado is highly correlated with Riesgo and 5 other fields | High correlation |
Perfil Riesgo is highly correlated with Riesgo and 1 other fields | High correlation |
Egresos_mensuales is highly correlated with Ingresos_mensuales | High correlation |
Cod_Ciudad_Nac. is highly correlated with Id Modificado and 2 other fields | High correlation |
Ocupacion is highly correlated with Id Modificado and 2 other fields | High correlation |
Ingresos_mensuales is highly correlated with Otros_Ing_Mensuales and 2 other fields | High correlation |
Total_Activos is highly correlated with Otros_Ing_Mensuales and 1 other fields | High correlation |
Codigo CIIU is highly correlated with CIIU | High correlation |
Transacciones Adiciones is highly correlated with Transacciones Retiros and 1 other fields | High correlation |
Departamento is highly correlated with Cod_Ciudad_Nac. and 1 other fields | High correlation |
Cod. Ocupacion is highly correlated with Id Modificado and 2 other fields | High correlation |
CIIU is highly correlated with Id Modificado and 3 other fields | High correlation |
Transacciones is highly correlated with Transacciones Retiros and 1 other fields | High correlation |
Cod Dpto.Nacimto. is highly correlated with Cod_Ciudad_Nac. and 1 other fields | High correlation |
Riesgo is highly correlated with Tipo Cliente and 2 other fields | High correlation |
Tipo Cliente is highly correlated with Riesgo and 5 other fields | High correlation |
Ocupacion is highly correlated with Tipo Cliente and 2 other fields | High correlation |
Perfil Riesgo is highly correlated with Riesgo and 2 other fields | High correlation |
cant is highly correlated with Riesgo and 5 other fields | High correlation |
Departamento is highly correlated with Tipo Cliente and 1 other fields | High correlation |
CIIU is highly correlated with Tipo Cliente and 2 other fields | High correlation |
Ingresos_mensuales is highly skewed (γ1 = 177.9249995) | Skewed |
Egresos_mensuales is highly skewed (γ1 = 178.0577763) | Skewed |
Otros_Ing_Mensuales is highly skewed (γ1 = 120.9799996) | Skewed |
Total_Activos is highly skewed (γ1 = 143.832213) | Skewed |
Total_Pasivos is highly skewed (γ1 = 139.5551282) | Skewed |
Saldo is highly skewed (γ1 = 66.44705337) | Skewed |
Id Modificado is uniformly distributed | Uniform |
Id Modificado has unique values | Unique |
Codigo CIIU has 20155 (63.5%) zeros | Zeros |
Cod Dpto.Nacimto. has 797 (2.5%) zeros | Zeros |
Cod. Ocupacion has 20158 (63.5%) zeros | Zeros |
Ingresos_mensuales has 20157 (63.5%) zeros | Zeros |
Egresos_mensuales has 20180 (63.6%) zeros | Zeros |
Otros_Ing_Mensuales has 26743 (84.3%) zeros | Zeros |
Total_Activos has 20176 (63.6%) zeros | Zeros |
Total_Pasivos has 22580 (71.2%) zeros | Zeros |
Saldo has 22013 (69.4%) zeros | Zeros |
Transacciones has 12588 (39.7%) zeros | Zeros |
Transacciones Adiciones has 12593 (39.7%) zeros | Zeros |
Transacciones Retiros has 18546 (58.4%) zeros | Zeros |
Reproduction
| Analysis started | 2021-05-24 04:20:45.054945 |
|---|---|
| Analysis finished | 2021-05-24 04:22:15.838439 |
| Duration | 1 minute and 30.78 seconds |
| Software version | pandas-profiling v3.0.0 |
| Download configuration | config.json |
Fecha Registro
Date
| Distinct | 1234 |
|---|---|
| Distinct (%) | 3.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 248.0 KiB |
| Minimum | 2017-08-24 00:00:00 |
|---|---|
| Maximum | 2021-03-25 00:00:00 |
Id Modificado
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONUNIFORMUNIQUE| Distinct | 31734 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15936.7554 |
| Minimum | 1 |
|---|---|
| Maximum | 31854 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 248.0 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1606.65 |
| Q1 | 7982.25 |
| median | 15938.5 |
| Q3 | 23890.75 |
| 95-th percentile | 30262.35 |
| Maximum | 31854 |
| Range | 31853 |
| Interquartile range (IQR) | 15908.5 |
Descriptive statistics
| Standard deviation | 9188.124201 |
|---|---|
| Coefficient of variation (CV) | 0.5765366894 |
| Kurtosis | -1.199264991 |
| Mean | 15936.7554 |
| Median Absolute Deviation (MAD) | 7954.5 |
| Skewness | -0.0001147318079 |
| Sum | 505736996 |
| Variance | 84421626.33 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 2049 | 1 | < 0.1% |
| 12979 | 1 | < 0.1% |
| 8881 | 1 | < 0.1% |
| 10928 | 1 | < 0.1% |
| 21151 | 1 | < 0.1% |
| 23198 | 1 | < 0.1% |
| 17053 | 1 | < 0.1% |
| 19100 | 1 | < 0.1% |
| 29339 | 1 | < 0.1% |
| 31386 | 1 | < 0.1% |
| Other values (31724) | 31724 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 |
| Value | Count | Frequency (%) |
| 31854 | 1 | |
| 31853 | 1 | |
| 31852 | 1 | |
| 31851 | 1 | |
| 31850 | 1 | |
| 31849 | 1 | |
| 31848 | 1 | |
| 31847 | 1 | |
| 31846 | 1 | |
| 31845 | 1 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 248.0 KiB |
| Ualet puro |
|---|
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 317340 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Ualet puro |
|---|---|
| 2nd row | Ualet puro |
| 3rd row | Ualet puro |
| 4th row | Ualet puro |
| 5th row | Ualet puro |
Common Values
| Value | Count | Frequency (%) |
| Ualet puro | 31734 |
Length
Pie chart
| Value | Count | Frequency (%) |
| puro | 31734 | |
| ualet | 31734 |
Most occurring characters
| Value | Count | Frequency (%) |
| U | 31734 | |
| a | 31734 | |
| l | 31734 | |
| e | 31734 | |
| t | 31734 | |
| 31734 | ||
| p | 31734 | |
| u | 31734 | |
| r | 31734 | |
| o | 31734 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 253872 | |
| Uppercase Letter | 31734 | 10.0% |
| Space Separator | 31734 | 10.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 31734 | |
| l | 31734 | |
| e | 31734 | |
| t | 31734 | |
| p | 31734 | |
| u | 31734 | |
| r | 31734 | |
| o | 31734 |
Uppercase Letter
| Value | Count | Frequency (%) |
| U | 31734 |
Space Separator
| Value | Count | Frequency (%) |
| 31734 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 285606 | |
| Common | 31734 | 10.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| U | 31734 | |
| a | 31734 | |
| l | 31734 | |
| e | 31734 | |
| t | 31734 | |
| p | 31734 | |
| u | 31734 | |
| r | 31734 | |
| o | 31734 |
Common
| Value | Count | Frequency (%) |
| 31734 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 317340 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| U | 31734 | |
| a | 31734 | |
| l | 31734 | |
| e | 31734 | |
| t | 31734 | |
| 31734 | ||
| p | 31734 | |
| u | 31734 | |
| r | 31734 | |
| o | 31734 |
| Distinct | 3187 |
|---|---|
| Distinct (%) | 10.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 248.0 KiB |
| JUAN | 2367 |
|---|---|
| CARLOS | 901 |
| LUIS | 888 |
| ANDRES | 796 |
| JOSE | 706 |
| Other values (3182) |
Length
| Max length | 13 |
|---|---|
| Median length | 6 |
| Mean length | 5.76353438 |
| Min length | 1 |
Characters and Unicode
| Total characters | 182900 |
|---|---|
| Distinct characters | 48 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 2019 ? |
|---|---|
| Unique (%) | 6.4% |
Sample
| 1st row | DANIEL |
|---|---|
| 2nd row | JESSICA |
| 3rd row | DAVID |
| 4th row | DIEGO |
| 5th row | NICOLÁS |
Common Values
| Value | Count | Frequency (%) |
| JUAN | 2367 | 7.5% |
| CARLOS | 901 | 2.8% |
| LUIS | 888 | 2.8% |
| ANDRES | 796 | 2.5% |
| JOSE | 706 | 2.2% |
| DANIEL | 677 | 2.1% |
| DIEGO | 634 | 2.0% |
| CRISTIAN | 523 | 1.6% |
| JORGE | 516 | 1.6% |
| DAVID | 508 | 1.6% |
| Other values (3177) | 23218 |
Length
| Value | Count | Frequency (%) |
| juan | 2370 | 7.5% |
| carlos | 901 | 2.8% |
| luis | 888 | 2.8% |
| andres | 796 | 2.5% |
| jose | 706 | 2.2% |
| daniel | 678 | 2.1% |
| diego | 634 | 2.0% |
| cristian | 523 | 1.6% |
| jorge | 516 | 1.6% |
| david | 509 | 1.6% |
| Other values (3163) | 23213 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 26919 | |
| N | 18223 | |
| I | 16600 | |
| E | 15397 | 8.4% |
| R | 14116 | 7.7% |
| O | 13181 | 7.2% |
| L | 11072 | 6.1% |
| S | 11035 | 6.0% |
| D | 8382 | 4.6% |
| J | 7903 | 4.3% |
| Other values (38) | 40072 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 182866 | |
| Other Punctuation | 9 | < 0.1% |
| Modifier Symbol | 8 | < 0.1% |
| Math Symbol | 6 | < 0.1% |
| Decimal Number | 6 | < 0.1% |
| Final Punctuation | 2 | < 0.1% |
| Open Punctuation | 2 | < 0.1% |
| Initial Punctuation | 1 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 26919 | |
| N | 18223 | |
| I | 16600 | |
| E | 15397 | 8.4% |
| R | 14116 | 7.7% |
| O | 13181 | 7.2% |
| L | 11072 | 6.1% |
| S | 11035 | 6.0% |
| D | 8382 | 4.6% |
| J | 7903 | 4.3% |
| Other values (23) | 40038 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 3 | |
| * | 2 | |
| " | 1 | 11.1% |
| \ | 1 | 11.1% |
| / | 1 | 11.1% |
| : | 1 | 11.1% |
Math Symbol
| Value | Count | Frequency (%) |
| ~ | 4 | |
| | | 2 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 5 | |
| 0 | 1 | 16.7% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1 | |
| [ | 1 |
Modifier Symbol
| Value | Count | Frequency (%) |
| ^ | 8 |
Final Punctuation
| Value | Count | Frequency (%) |
| » | 2 |
Initial Punctuation
| Value | Count | Frequency (%) |
| « | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 182866 | |
| Common | 34 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 26919 | |
| N | 18223 | |
| I | 16600 | |
| E | 15397 | 8.4% |
| R | 14116 | 7.7% |
| O | 13181 | 7.2% |
| L | 11072 | 6.1% |
| S | 11035 | 6.0% |
| D | 8382 | 4.6% |
| J | 7903 | 4.3% |
| Other values (23) | 40038 |
Common
| Value | Count | Frequency (%) |
| ^ | 8 | |
| 1 | 5 | |
| ~ | 4 | |
| ' | 3 | 8.8% |
| | | 2 | 5.9% |
| * | 2 | 5.9% |
| » | 2 | 5.9% |
| " | 1 | 2.9% |
| ( | 1 | 2.9% |
| « | 1 | 2.9% |
| Other values (5) | 5 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 181822 | |
| Latin 1 Sup | 1078 | 0.6% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 26919 | |
| N | 18223 | |
| I | 16600 | |
| E | 15397 | 8.5% |
| R | 14116 | 7.8% |
| O | 13181 | 7.2% |
| L | 11072 | 6.1% |
| S | 11035 | 6.1% |
| D | 8382 | 4.6% |
| J | 7903 | 4.3% |
| Other values (29) | 38994 |
Latin 1 Sup
| Value | Count | Frequency (%) |
| É | 488 | |
| Á | 357 | |
| Í | 131 | 12.2% |
| Ú | 59 | 5.5% |
| Ó | 37 | 3.4% |
| Ñ | 2 | 0.2% |
| » | 2 | 0.2% |
| Ì | 1 | 0.1% |
| « | 1 | 0.1% |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 248.0 KiB |
| 2 | |
|---|---|
| 3 | |
| 4 | |
| 1 | |
| 5 | 629 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 31734 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 3 |
| 3rd row | 2 |
| 4th row | 2 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 13330 | |
| 3 | 10961 | |
| 4 | 4098 | 12.9% |
| 1 | 2716 | 8.6% |
| 5 | 629 | 2.0% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 2 | 13330 | |
| 3 | 10961 | |
| 4 | 4098 | 12.9% |
| 1 | 2716 | 8.6% |
| 5 | 629 | 2.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 13330 | |
| 3 | 10961 | |
| 4 | 4098 | 12.9% |
| 1 | 2716 | 8.6% |
| 5 | 629 | 2.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 31734 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 13330 | |
| 3 | 10961 | |
| 4 | 4098 | 12.9% |
| 1 | 2716 | 8.6% |
| 5 | 629 | 2.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 31734 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 13330 | |
| 3 | 10961 | |
| 4 | 4098 | 12.9% |
| 1 | 2716 | 8.6% |
| 5 | 629 | 2.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 31734 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 13330 | |
| 3 | 10961 | |
| 4 | 4098 | 12.9% |
| 1 | 2716 | 8.6% |
| 5 | 629 | 2.0% |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 248.0 KiB |
| Aventurero | |
|---|---|
| Estratega | |
| Planeador | |
| Valiente | |
| Cuidadoso | 629 |
Length
| Max length | 10 |
|---|---|
| Median length | 9 |
| Mean length | 9.334467763 |
| Min length | 8 |
Characters and Unicode
| Total characters | 296220 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Valiente |
|---|---|
| 2nd row | Estratega |
| 3rd row | Aventurero |
| 4th row | Aventurero |
| 5th row | Valiente |
Common Values
| Value | Count | Frequency (%) |
| Aventurero | 13330 | |
| Estratega | 10961 | |
| Planeador | 4098 | 12.9% |
| Valiente | 2716 | 8.6% |
| Cuidadoso | 629 | 2.0% |
Length
Pie chart
| Value | Count | Frequency (%) |
| aventurero | 13330 | |
| estratega | 10961 | |
| planeador | 4098 | 12.9% |
| valiente | 2716 | 8.6% |
| cuidadoso | 629 | 2.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 47151 | |
| r | 41719 | |
| t | 37968 | |
| a | 33463 | |
| n | 20144 | |
| o | 18686 | 6.3% |
| u | 13959 | 4.7% |
| A | 13330 | 4.5% |
| v | 13330 | 4.5% |
| s | 11590 | 3.9% |
| Other values (8) | 44880 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 264486 | |
| Uppercase Letter | 31734 | 10.7% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 47151 | |
| r | 41719 | |
| t | 37968 | |
| a | 33463 | |
| n | 20144 | |
| o | 18686 | 7.1% |
| u | 13959 | 5.3% |
| v | 13330 | 5.0% |
| s | 11590 | 4.4% |
| g | 10961 | 4.1% |
| Other values (3) | 15515 | 5.9% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 13330 | |
| E | 10961 | |
| P | 4098 | 12.9% |
| V | 2716 | 8.6% |
| C | 629 | 2.0% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 296220 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 47151 | |
| r | 41719 | |
| t | 37968 | |
| a | 33463 | |
| n | 20144 | |
| o | 18686 | 6.3% |
| u | 13959 | 4.7% |
| A | 13330 | 4.5% |
| v | 13330 | 4.5% |
| s | 11590 | 3.9% |
| Other values (8) | 44880 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 296220 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 47151 | |
| r | 41719 | |
| t | 37968 | |
| a | 33463 | |
| n | 20144 | |
| o | 18686 | 6.3% |
| u | 13959 | 4.7% |
| A | 13330 | 4.5% |
| v | 13330 | 4.5% |
| s | 11590 | 3.9% |
| Other values (8) | 44880 |
| Distinct | 311 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 262.4177538 |
| Minimum | 0 |
|---|---|
| Maximum | 9820 |
| Zeros | 20155 |
| Zeros (%) | 63.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 248.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 10 |
| 95-th percentile | 496 |
| Maximum | 9820 |
| Range | 9820 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 1253.606277 |
|---|---|
| Coefficient of variation (CV) | 4.777139728 |
| Kurtosis | 28.24183142 |
| Mean | 262.4177538 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.362802937 |
| Sum | 8327565 |
| Variance | 1571528.698 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 20155 | |
| 10 | 5621 | 17.7% |
| 90 | 1921 | 6.1% |
| 81 | 1876 | 5.9% |
| 496 | 559 | 1.8% |
| 497 | 136 | 0.4% |
| 6201 | 91 | 0.3% |
| 1 | 77 | 0.2% |
| 7110 | 40 | 0.1% |
| 6920 | 39 | 0.1% |
| Other values (301) | 1219 | 3.8% |
| Value | Count | Frequency (%) |
| 0 | 20155 | |
| 1 | 77 | 0.2% |
| 6 | 1 | < 0.1% |
| 10 | 5621 | 17.7% |
| 20 | 1 | < 0.1% |
| 62 | 1 | < 0.1% |
| 67 | 1 | < 0.1% |
| 81 | 1876 | 5.9% |
| 82 | 38 | 0.1% |
| 85 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 9820 | 1 | < 0.1% |
| 9700 | 3 | < 0.1% |
| 9609 | 6 | |
| 9602 | 10 | |
| 9601 | 1 | < 0.1% |
| 9521 | 5 | |
| 9512 | 3 | < 0.1% |
| 9511 | 9 | |
| 9412 | 1 | < 0.1% |
| 9329 | 1 | < 0.1% |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 248.0 KiB |
| Bajo | |
|---|---|
| Medio | |
| Sin Clasificar | 2002 |
| Alto | 93 |
Length
| Max length | 14 |
|---|---|
| Median length | 4 |
| Mean length | 4.80847041 |
| Min length | 4 |
Characters and Unicode
| Total characters | 152592 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Medio |
|---|---|
| 2nd row | Alto |
| 3rd row | Sin Clasificar |
| 4th row | Alto |
| 5th row | Alto |
Common Values
| Value | Count | Frequency (%) |
| Bajo | 24003 | |
| Medio | 5636 | 17.8% |
| Sin Clasificar | 2002 | 6.3% |
| Alto | 93 | 0.3% |
Length
Pie chart
| Value | Count | Frequency (%) |
| bajo | 24003 | |
| medio | 5636 | 16.7% |
| clasificar | 2002 | 5.9% |
| sin | 2002 | 5.9% |
| alto | 93 | 0.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 29732 | |
| a | 28007 | |
| B | 24003 | |
| j | 24003 | |
| i | 11642 | 7.6% |
| M | 5636 | 3.7% |
| e | 5636 | 3.7% |
| d | 5636 | 3.7% |
| l | 2095 | 1.4% |
| S | 2002 | 1.3% |
| Other values (9) | 14200 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 116854 | |
| Uppercase Letter | 33736 | 22.1% |
| Space Separator | 2002 | 1.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 29732 | |
| a | 28007 | |
| j | 24003 | |
| i | 11642 | 10.0% |
| e | 5636 | 4.8% |
| d | 5636 | 4.8% |
| l | 2095 | 1.8% |
| n | 2002 | 1.7% |
| s | 2002 | 1.7% |
| f | 2002 | 1.7% |
| Other values (3) | 4097 | 3.5% |
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 24003 | |
| M | 5636 | 16.7% |
| S | 2002 | 5.9% |
| C | 2002 | 5.9% |
| A | 93 | 0.3% |
Space Separator
| Value | Count | Frequency (%) |
| 2002 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 150590 | |
| Common | 2002 | 1.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 29732 | |
| a | 28007 | |
| B | 24003 | |
| j | 24003 | |
| i | 11642 | 7.7% |
| M | 5636 | 3.7% |
| e | 5636 | 3.7% |
| d | 5636 | 3.7% |
| l | 2095 | 1.4% |
| S | 2002 | 1.3% |
| Other values (8) | 12198 |
Common
| Value | Count | Frequency (%) |
| 2002 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 152592 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 29732 | |
| a | 28007 | |
| B | 24003 | |
| j | 24003 | |
| i | 11642 | 7.6% |
| M | 5636 | 3.7% |
| e | 5636 | 3.7% |
| d | 5636 | 3.7% |
| l | 2095 | 1.4% |
| S | 2002 | 1.3% |
| Other values (9) | 14200 |
| Distinct | 10468 |
|---|---|
| Distinct (%) | 33.0% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 248.0 KiB |
| Minimum | 1934-07-30 00:00:00 |
|---|---|
| Maximum | 2026-08-26 00:00:00 |
Cod_Ciudad_Nac.
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 6849 |
|---|---|
| Distinct (%) | 21.6% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29376.87527 |
| Minimum | 5001 |
|---|---|
| Maximum | 229309 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 248.0 KiB |
Quantile statistics
| Minimum | 5001 |
|---|---|
| 5-th percentile | 5001 |
| Q1 | 11001 |
| median | 25430 |
| Q3 | 36386 |
| 95-th percentile | 76001 |
| Maximum | 229309 |
| Range | 224308 |
| Interquartile range (IQR) | 25385 |
Descriptive statistics
| Standard deviation | 23209.14872 |
|---|---|
| Coefficient of variation (CV) | 0.790048244 |
| Kurtosis | 4.002213499 |
| Mean | 29376.87527 |
| Median Absolute Deviation (MAD) | 14429 |
| Skewness | 1.419535783 |
| Sum | 932216383 |
| Variance | 538664584.4 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 11001 | 7047 | 22.2% |
| 5001 | 1919 | 6.0% |
| 76001 | 1145 | 3.6% |
| 8001 | 666 | 2.1% |
| 12244 | 627 | 2.0% |
| 68001 | 495 | 1.6% |
| 13001 | 367 | 1.2% |
| 54001 | 328 | 1.0% |
| 17001 | 309 | 1.0% |
| 66001 | 290 | 0.9% |
| Other values (6839) | 18540 |
| Value | Count | Frequency (%) |
| 5001 | 1919 | |
| 5002 | 17 | 0.1% |
| 5004 | 1 | < 0.1% |
| 5021 | 5 | < 0.1% |
| 5030 | 8 | < 0.1% |
| 5031 | 10 | < 0.1% |
| 5034 | 19 | 0.1% |
| 5036 | 1 | < 0.1% |
| 5038 | 2 | < 0.1% |
| 5040 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 229309 | 1 | < 0.1% |
| 209839 | 2 | < 0.1% |
| 209832 | 1 | < 0.1% |
| 209758 | 24 | |
| 209692 | 1 | < 0.1% |
| 209625 | 2 | < 0.1% |
| 208094 | 1 | < 0.1% |
| 207962 | 1 | < 0.1% |
| 204991 | 1 | < 0.1% |
| 204106 | 1 | < 0.1% |
| Distinct | 844 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 248.0 KiB |
| Sin ciudad | |
|---|---|
| BOGOTA D.C. | |
| MEDELLIN | |
| CALI | |
| BARRANQUILLA | 666 |
| Other values (839) |
Length
| Max length | 34 |
|---|---|
| Median length | 10 |
| Mean length | 9.426640197 |
| Min length | 3 |
Characters and Unicode
| Total characters | 299145 |
|---|---|
| Distinct characters | 39 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 161 ? |
|---|---|
| Unique (%) | 0.5% |
Sample
| 1st row | BOGOTA D.C. |
|---|---|
| 2nd row | BOGOTA D.C. |
| 3rd row | BOGOTA D.C. |
| 4th row | BOGOTA D.C. |
| 5th row | BOGOTA D.C. |
Common Values
| Value | Count | Frequency (%) |
| Sin ciudad | 10334 | |
| BOGOTA D.C. | 7047 | |
| MEDELLIN | 1919 | 6.0% |
| CALI | 1145 | 3.6% |
| BARRANQUILLA | 666 | 2.1% |
| BUCARAMANGA | 495 | 1.6% |
| CARTAGENA | 367 | 1.2% |
| CUCUTA | 328 | 1.0% |
| MANIZALES | 309 | 1.0% |
| PEREIRA | 290 | 0.9% |
| Other values (834) | 8834 |
Length
| Value | Count | Frequency (%) |
| ciudad | 10348 | |
| sin | 10334 | |
| bogota | 7047 | |
| d.c | 7047 | |
| medellin | 1919 | 3.7% |
| cali | 1145 | 2.2% |
| barranquilla | 666 | 1.3% |
| bucaramanga | 495 | 1.0% |
| cartagena | 369 | 0.7% |
| de | 359 | 0.7% |
| Other values (845) | 11659 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 28922 | 9.7% |
| i | 20668 | 6.9% |
| d | 20668 | 6.9% |
| 19654 | 6.6% | |
| O | 19377 | 6.5% |
| . | 14094 | 4.7% |
| S | 13717 | 4.6% |
| C | 12969 | 4.3% |
| T | 11072 | 3.7% |
| D | 10975 | 3.7% |
| Other values (29) | 127029 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 182665 | |
| Lowercase Letter | 82672 | |
| Space Separator | 19654 | 6.6% |
| Other Punctuation | 14094 | 4.7% |
| Open Punctuation | 30 | < 0.1% |
| Close Punctuation | 30 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 28922 | |
| O | 19377 | |
| S | 13717 | 7.5% |
| C | 12969 | 7.1% |
| T | 11072 | 6.1% |
| D | 10975 | 6.0% |
| L | 10784 | 5.9% |
| I | 10425 | 5.7% |
| E | 10424 | 5.7% |
| B | 10016 | 5.5% |
| Other values (19) | 43984 |
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 20668 | |
| d | 20668 | |
| n | 10334 | |
| c | 10334 | |
| u | 10334 | |
| a | 10334 |
Space Separator
| Value | Count | Frequency (%) |
| 19654 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 14094 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 30 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 30 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 265337 | |
| Common | 33808 | 11.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 28922 | 10.9% |
| i | 20668 | 7.8% |
| d | 20668 | 7.8% |
| O | 19377 | 7.3% |
| S | 13717 | 5.2% |
| C | 12969 | 4.9% |
| T | 11072 | 4.2% |
| D | 10975 | 4.1% |
| L | 10784 | 4.1% |
| I | 10425 | 3.9% |
| Other values (25) | 105760 |
Common
| Value | Count | Frequency (%) |
| 19654 | ||
| . | 14094 | |
| ( | 30 | 0.1% |
| ) | 30 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 299035 | |
| Latin 1 Sup | 110 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 28922 | 9.7% |
| i | 20668 | 6.9% |
| d | 20668 | 6.9% |
| 19654 | 6.6% | |
| O | 19377 | 6.5% |
| . | 14094 | 4.7% |
| S | 13717 | 4.6% |
| C | 12969 | 4.3% |
| T | 11072 | 3.7% |
| D | 10975 | 3.7% |
| Other values (25) | 126919 |
Latin 1 Sup
| Value | Count | Frequency (%) |
| Ñ | 94 | |
| Ú | 6 | 5.5% |
| Í | 6 | 5.5% |
| Ó | 4 | 3.6% |
Cod Dpto.Nacimto.
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 34 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.82000378 |
| Minimum | 0 |
|---|---|
| Maximum | 99 |
| Zeros | 797 |
| Zeros (%) | 2.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 248.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 11 |
| median | 11 |
| Q3 | 52 |
| 95-th percentile | 76 |
| Maximum | 99 |
| Range | 99 |
| Interquartile range (IQR) | 41 |
Descriptive statistics
| Standard deviation | 26.34662842 |
|---|---|
| Coefficient of variation (CV) | 0.9470389949 |
| Kurtosis | -0.7399373098 |
| Mean | 27.82000378 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 0.9425528167 |
| Sum | 882840 |
| Variance | 694.1448291 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 11 | 9928 | |
| 5 | 4578 | |
| 76 | 2640 | 8.3% |
| 68 | 1402 | 4.4% |
| 25 | 1334 | 4.2% |
| 8 | 1136 | 3.6% |
| 15 | 1003 | 3.2% |
| 73 | 833 | 2.6% |
| 17 | 801 | 2.5% |
| 0 | 797 | 2.5% |
| Other values (24) | 7282 |
| Value | Count | Frequency (%) |
| 0 | 797 | 2.5% |
| 5 | 4578 | |
| 8 | 1136 | 3.6% |
| 11 | 9928 | |
| 13 | 764 | 2.4% |
| 15 | 1003 | 3.2% |
| 17 | 801 | 2.5% |
| 18 | 202 | 0.6% |
| 19 | 436 | 1.4% |
| 20 | 401 | 1.3% |
| Value | Count | Frequency (%) |
| 99 | 12 | < 0.1% |
| 97 | 7 | < 0.1% |
| 95 | 41 | 0.1% |
| 94 | 13 | < 0.1% |
| 91 | 43 | 0.1% |
| 88 | 47 | 0.1% |
| 86 | 142 | 0.4% |
| 85 | 152 | 0.5% |
| 81 | 118 | 0.4% |
| 76 | 2640 |
| Distinct | 34 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 248.0 KiB |
| BOGOTA | |
|---|---|
| ANTIOQUIA | |
| VALLE DEL CAUCA | |
| SANTANDER | |
| CUNDINAMARCA | |
| Other values (29) |
Length
| Max length | 18 |
|---|---|
| Median length | 7 |
| Mean length | 8.317987017 |
| Min length | 4 |
Characters and Unicode
| Total characters | 263963 |
|---|---|
| Distinct characters | 34 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BOGOTA |
|---|---|
| 2nd row | BOGOTA |
| 3rd row | BOGOTA |
| 4th row | BOGOTA |
| 5th row | BOGOTA |
Common Values
| Value | Count | Frequency (%) |
| BOGOTA | 9928 | |
| ANTIOQUIA | 4578 | |
| VALLE DEL CAUCA | 2640 | 8.3% |
| SANTANDER | 1402 | 4.4% |
| CUNDINAMARCA | 1334 | 4.2% |
| ATLANTICO | 1136 | 3.6% |
| BOYACA | 1003 | 3.2% |
| TOLIMA | 833 | 2.6% |
| CALDAS | 801 | 2.5% |
| Sin departamento | 797 | 2.5% |
| Other values (24) | 7282 |
Length
| Value | Count | Frequency (%) |
| bogota | 9928 | |
| antioquia | 4578 | |
| cauca | 3076 | 7.8% |
| valle | 2640 | 6.7% |
| del | 2640 | 6.7% |
| santander | 2143 | 5.4% |
| cundinamarca | 1334 | 3.4% |
| atlantico | 1136 | 2.9% |
| boyaca | 1003 | 2.5% |
| tolima | 833 | 2.1% |
| Other values (29) | 10237 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 51460 | |
| O | 31405 | |
| T | 21327 | 8.1% |
| I | 15956 | 6.0% |
| N | 15065 | 5.7% |
| C | 13732 | 5.2% |
| L | 13187 | 5.0% |
| B | 12236 | 4.6% |
| U | 11071 | 4.2% |
| E | 10916 | 4.1% |
| Other values (24) | 67608 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 244991 | |
| Lowercase Letter | 11158 | 4.2% |
| Space Separator | 7814 | 3.0% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 51460 | |
| O | 31405 | |
| T | 21327 | |
| I | 15956 | 6.5% |
| N | 15065 | 6.1% |
| C | 13732 | 5.6% |
| L | 13187 | 5.4% |
| B | 12236 | 5.0% |
| U | 11071 | 4.5% |
| E | 10916 | 4.5% |
| Other values (13) | 48636 |
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 1594 | |
| e | 1594 | |
| a | 1594 | |
| t | 1594 | |
| i | 797 | |
| d | 797 | |
| p | 797 | |
| r | 797 | |
| m | 797 | |
| o | 797 |
Space Separator
| Value | Count | Frequency (%) |
| 7814 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 256149 | |
| Common | 7814 | 3.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 51460 | |
| O | 31405 | |
| T | 21327 | 8.3% |
| I | 15956 | 6.2% |
| N | 15065 | 5.9% |
| C | 13732 | 5.4% |
| L | 13187 | 5.1% |
| B | 12236 | 4.8% |
| U | 11071 | 4.3% |
| E | 10916 | 4.3% |
| Other values (23) | 59794 |
Common
| Value | Count | Frequency (%) |
| 7814 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 263301 | |
| Latin 1 Sup | 662 | 0.3% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 51460 | |
| O | 31405 | |
| T | 21327 | 8.1% |
| I | 15956 | 6.1% |
| N | 15065 | 5.7% |
| C | 13732 | 5.2% |
| L | 13187 | 5.0% |
| B | 12236 | 4.6% |
| U | 11071 | 4.2% |
| E | 10916 | 4.1% |
| Other values (23) | 66946 |
Latin 1 Sup
| Value | Count | Frequency (%) |
| Ñ | 662 |
Cod. Ocupacion
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.7012352682 |
| Minimum | 0 |
|---|---|
| Maximum | 10 |
| Zeros | 20158 |
| Zeros (%) | 63.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 248.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.012922081 |
|---|---|
| Coefficient of variation (CV) | 1.444482511 |
| Kurtosis | -0.1457204395 |
| Mean | 0.7012352682 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.06447323 |
| Sum | 22253 |
| Variance | 1.026011142 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 20158 | |
| 2 | 6376 | 20.1% |
| 1 | 3085 | 9.7% |
| 3 | 2050 | 6.5% |
| 4 | 64 | 0.2% |
| 10 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 20158 | |
| 1 | 3085 | 9.7% |
| 2 | 6376 | 20.1% |
| 3 | 2050 | 6.5% |
| 4 | 64 | 0.2% |
| 10 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 10 | 1 | < 0.1% |
| 4 | 64 | 0.2% |
| 3 | 2050 | 6.5% |
| 2 | 6376 | 20.1% |
| 1 | 3085 | 9.7% |
| 0 | 20158 |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 248.0 KiB |
| Codigo no esta Creado | |
|---|---|
| EMPLEADO | |
| INDEPENDIENTE | |
| ESTUDIANTE |
Length
| Max length | 21 |
|---|---|
| Median length | 21 |
| Mean length | 16.899729 |
| Min length | 8 |
Characters and Unicode
| Total characters | 536296 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | EMPLEADO |
|---|---|
| 2nd row | ESTUDIANTE |
| 3rd row | EMPLEADO |
| 4th row | EMPLEADO |
| 5th row | ESTUDIANTE |
Common Values
| Value | Count | Frequency (%) |
| Codigo no esta Creado | 20223 | |
| EMPLEADO | 6376 | 20.1% |
| INDEPENDIENTE | 3085 | 9.7% |
| ESTUDIANTE | 2050 | 6.5% |
Length
Pie chart
| Value | Count | Frequency (%) |
| codigo | 20223 | |
| creado | 20223 | |
| no | 20223 | |
| esta | 20223 | |
| empleado | 6376 | 6.9% |
| independiente | 3085 | 3.3% |
| estudiante | 2050 | 2.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 80892 | |
| 60669 | ||
| C | 40446 | 7.5% |
| d | 40446 | 7.5% |
| e | 40446 | 7.5% |
| a | 40446 | 7.5% |
| E | 29192 | 5.4% |
| i | 20223 | 3.8% |
| g | 20223 | 3.8% |
| n | 20223 | 3.8% |
| Other values (14) | 143090 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 323568 | |
| Uppercase Letter | 152059 | |
| Space Separator | 60669 | 11.3% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 40446 | |
| E | 29192 | |
| D | 14596 | 9.6% |
| N | 11305 | 7.4% |
| P | 9461 | 6.2% |
| A | 8426 | 5.5% |
| I | 8220 | 5.4% |
| T | 7185 | 4.7% |
| M | 6376 | 4.2% |
| L | 6376 | 4.2% |
| Other values (3) | 10476 | 6.9% |
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 80892 | |
| d | 40446 | |
| e | 40446 | |
| a | 40446 | |
| i | 20223 | 6.2% |
| g | 20223 | 6.2% |
| n | 20223 | 6.2% |
| s | 20223 | 6.2% |
| t | 20223 | 6.2% |
| r | 20223 | 6.2% |
Space Separator
| Value | Count | Frequency (%) |
| 60669 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 475627 | |
| Common | 60669 | 11.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 80892 | |
| C | 40446 | 8.5% |
| d | 40446 | 8.5% |
| e | 40446 | 8.5% |
| a | 40446 | 8.5% |
| E | 29192 | 6.1% |
| i | 20223 | 4.3% |
| g | 20223 | 4.3% |
| n | 20223 | 4.3% |
| s | 20223 | 4.3% |
| Other values (13) | 122867 |
Common
| Value | Count | Frequency (%) |
| 60669 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 536296 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 80892 | |
| 60669 | ||
| C | 40446 | 7.5% |
| d | 40446 | 7.5% |
| e | 40446 | 7.5% |
| a | 40446 | 7.5% |
| E | 29192 | 5.4% |
| i | 20223 | 3.8% |
| g | 20223 | 3.8% |
| n | 20223 | 3.8% |
| Other values (14) | 143090 |
Ingresos_mensuales
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONSKEWEDZEROS| Distinct | 929 |
|---|---|
| Distinct (%) | 2.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4231418.131 |
| Minimum | 0 |
|---|---|
| Maximum | 1 × 1011 |
| Zeros | 20157 |
| Zeros (%) | 63.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 248.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1000000 |
| 95-th percentile | 4500000 |
| Maximum | 1 × 1011 |
| Range | 1 × 1011 |
| Interquartile range (IQR) | 1000000 |
Descriptive statistics
| Standard deviation | 561578256 |
|---|---|
| Coefficient of variation (CV) | 132.7163231 |
| Kurtosis | 31682.20127 |
| Mean | 4231418.131 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 177.9249995 |
| Sum | 1.34279823 × 1011 |
| Variance | 3.153701377 × 1017 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 20157 | |
| 1000000 | 1071 | 3.4% |
| 2000000 | 810 | 2.6% |
| 1500000 | 551 | 1.7% |
| 800000 | 507 | 1.6% |
| 3000000 | 492 | 1.6% |
| 1200000 | 462 | 1.5% |
| 500000 | 348 | 1.1% |
| 2500000 | 307 | 1.0% |
| 5000000 | 303 | 1.0% |
| Other values (919) | 6726 | 21.2% |
| Value | Count | Frequency (%) |
| 0 | 20157 | |
| 400 | 1 | < 0.1% |
| 4102 | 1 | < 0.1% |
| 10000 | 86 | 0.3% |
| 12000 | 1 | < 0.1% |
| 15000 | 5 | < 0.1% |
| 17000 | 1 | < 0.1% |
| 20000 | 33 | 0.1% |
| 25000 | 5 | < 0.1% |
| 30000 | 12 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 × 1011 | 1 | |
| 2151495550 | 1 | |
| 1770000000 | 1 | |
| 345345345 | 1 | |
| 231000000 | 1 | |
| 150000000 | 1 | |
| 90000000 | 1 | |
| 85000000 | 1 | |
| 82811600 | 1 | |
| 70000000 | 1 |
| Distinct | 389 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3801602.816 |
| Minimum | 0 |
|---|---|
| Maximum | 1.0000001 × 1011 |
| Zeros | 20180 |
| Zeros (%) | 63.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 248.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 500000 |
| 95-th percentile | 2500000 |
| Maximum | 1.0000001 × 1011 |
| Range | 1.0000001 × 1011 |
| Interquartile range (IQR) | 500000 |
Descriptive statistics
| Standard deviation | 561438769.5 |
|---|---|
| Coefficient of variation (CV) | 147.6847521 |
| Kurtosis | 31714.2503 |
| Mean | 3801602.816 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 178.0577763 |
| Sum | 1.206400638 × 1011 |
| Variance | 3.152134919 × 1017 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 20180 | |
| 1000000 | 872 | 2.7% |
| 500000 | 840 | 2.6% |
| 1500000 | 640 | 2.0% |
| 2000000 | 629 | 2.0% |
| 800000 | 626 | 2.0% |
| 600000 | 609 | 1.9% |
| 400000 | 489 | 1.5% |
| 700000 | 444 | 1.4% |
| 300000 | 398 | 1.3% |
| Other values (379) | 6007 | 18.9% |
| Value | Count | Frequency (%) |
| 0 | 20180 | |
| 1 | 16 | 0.1% |
| 2 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 10 | 6 | < 0.1% |
| 12 | 1 | < 0.1% |
| 20 | 1 | < 0.1% |
| 50 | 1 | < 0.1% |
| 60 | 1 | < 0.1% |
| 100 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 1.0000001 × 1011 | 1 | < 0.1% |
| 1250000000 | 1 | < 0.1% |
| 866299200 | 1 | < 0.1% |
| 600000404 | 1 | < 0.1% |
| 600000000 | 1 | < 0.1% |
| 100000000 | 1 | < 0.1% |
| 40000000 | 1 | < 0.1% |
| 35000000 | 2 | |
| 33000000 | 1 | < 0.1% |
| 30000000 | 3 |
Otros_Ing_Mensuales
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONSKEWEDZEROS| Distinct | 206 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 101517.6671 |
| Minimum | 0 |
|---|---|
| Maximum | 258000000 |
| Zeros | 26743 |
| Zeros (%) | 84.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 248.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 500000 |
| Maximum | 258000000 |
| Range | 258000000 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1670029.091 |
|---|---|
| Coefficient of variation (CV) | 16.45062519 |
| Kurtosis | 18056.76579 |
| Mean | 101517.6671 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 120.9799996 |
| Sum | 3221561647 |
| Variance | 2.788997166 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 26743 | |
| 100000 | 734 | 2.3% |
| 200000 | 674 | 2.1% |
| 500000 | 484 | 1.5% |
| 1000000 | 338 | 1.1% |
| 50000 | 316 | 1.0% |
| 300000 | 283 | 0.9% |
| 1 | 211 | 0.7% |
| 10000 | 174 | 0.5% |
| 400000 | 149 | 0.5% |
| Other values (196) | 1628 | 5.1% |
| Value | Count | Frequency (%) |
| 0 | 26743 | |
| 1 | 211 | 0.7% |
| 2 | 2 | < 0.1% |
| 3 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| 7 | 1 | < 0.1% |
| 10 | 29 | 0.1% |
| 12 | 1 | < 0.1% |
| 20 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 258000000 | 1 | < 0.1% |
| 60000000 | 1 | < 0.1% |
| 50000000 | 2 | < 0.1% |
| 45000000 | 1 | < 0.1% |
| 30000000 | 2 | < 0.1% |
| 26338000 | 1 | < 0.1% |
| 25000000 | 1 | < 0.1% |
| 20000000 | 6 | |
| 18000000 | 1 | < 0.1% |
| 15000000 | 2 | < 0.1% |
Total_Activos
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONSKEWEDZEROS| Distinct | 663 |
|---|---|
| Distinct (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22846094.16 |
| Minimum | 0 |
|---|---|
| Maximum | 1 × 1011 |
| Zeros | 20176 |
| Zeros (%) | 63.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 248.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1000000 |
| 95-th percentile | 80000000 |
| Maximum | 1 × 1011 |
| Range | 1 × 1011 |
| Interquartile range (IQR) | 1000000 |
Descriptive statistics
| Standard deviation | 615480671.6 |
|---|---|
| Coefficient of variation (CV) | 26.9403018 |
| Kurtosis | 22502.69339 |
| Mean | 22846094.16 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 143.832213 |
| Sum | 7.249979521 × 1011 |
| Variance | 3.788164571 × 1017 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 20176 | |
| 1000000 | 930 | 2.9% |
| 5000000 | 626 | 2.0% |
| 10000000 | 622 | 2.0% |
| 2000000 | 553 | 1.7% |
| 100000 | 481 | 1.5% |
| 500000 | 383 | 1.2% |
| 3000000 | 348 | 1.1% |
| 20000000 | 342 | 1.1% |
| 200000 | 295 | 0.9% |
| Other values (653) | 6978 | 22.0% |
| Value | Count | Frequency (%) |
| 0 | 20176 | |
| 1 | 3 | < 0.1% |
| 10 | 1 | < 0.1% |
| 4000 | 1 | < 0.1% |
| 10000 | 19 | 0.1% |
| 10100 | 1 | < 0.1% |
| 11000 | 3 | < 0.1% |
| 13000 | 3 | < 0.1% |
| 13001 | 1 | < 0.1% |
| 14000 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 × 1011 | 1 | < 0.1% |
| 4 × 1010 | 1 | < 0.1% |
| 5000000000 | 3 | |
| 3559000000 | 1 | < 0.1% |
| 3500000000 | 1 | < 0.1% |
| 3435000000 | 1 | < 0.1% |
| 3397874000 | 1 | < 0.1% |
| 3000000000 | 2 | |
| 2400000000 | 1 | < 0.1% |
| 2229850000 | 1 | < 0.1% |
| Distinct | 515 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7133180.942 |
| Minimum | 0 |
|---|---|
| Maximum | 1.740000003 × 1010 |
| Zeros | 22580 |
| Zeros (%) | 71.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 248.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 100000 |
| 95-th percentile | 30000000 |
| Maximum | 1.740000003 × 1010 |
| Range | 1.740000003 × 1010 |
| Interquartile range (IQR) | 100000 |
Descriptive statistics
| Standard deviation | 106238882.9 |
|---|---|
| Coefficient of variation (CV) | 14.89361952 |
| Kurtosis | 22656.77968 |
| Mean | 7133180.942 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 139.5551282 |
| Sum | 2.26364364 × 1011 |
| Variance | 1.128670024 × 1016 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 22580 | |
| 1000000 | 571 | 1.8% |
| 500000 | 407 | 1.3% |
| 100000 | 389 | 1.2% |
| 2000000 | 361 | 1.1% |
| 5000000 | 334 | 1.1% |
| 200000 | 302 | 1.0% |
| 3000000 | 254 | 0.8% |
| 10000000 | 251 | 0.8% |
| 300000 | 242 | 0.8% |
| Other values (505) | 6043 | 19.0% |
| Value | Count | Frequency (%) |
| 0 | 22580 | |
| 1 | 224 | 0.7% |
| 2 | 5 | < 0.1% |
| 3 | 5 | < 0.1% |
| 4 | 1 | < 0.1% |
| 5 | 4 | < 0.1% |
| 6 | 1 | < 0.1% |
| 10 | 28 | 0.1% |
| 11 | 1 | < 0.1% |
| 20 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1.740000003 × 1010 | 1 | |
| 2000000826 | 1 | |
| 2000000000 | 1 | |
| 1950000000 | 1 | |
| 1800000000 | 1 | |
| 1300000000 | 1 | |
| 1187990000 | 1 | |
| 1000000008 | 1 | |
| 1000000000 | 2 | |
| 900000000 | 1 |
| Distinct | 7948 |
|---|---|
| Distinct (%) | 25.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 157603.5221 |
| Minimum | 0 |
|---|---|
| Maximum | 231883698.8 |
| Zeros | 22013 |
| Zeros (%) | 69.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 248.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 10631.5675 |
| 95-th percentile | 318416.8165 |
| Maximum | 231883698.8 |
| Range | 231883698.8 |
| Interquartile range (IQR) | 10631.5675 |
Descriptive statistics
| Standard deviation | 2115046.623 |
|---|---|
| Coefficient of variation (CV) | 13.42004668 |
| Kurtosis | 6162.268949 |
| Mean | 157603.5221 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 66.44705337 |
| Sum | 5001390171 |
| Variance | 4.473422219 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 22013 | |
| 47842.85 | 269 | 0.8% |
| 28705.18 | 143 | 0.5% |
| 95685.19 | 52 | 0.2% |
| 47841.65 | 29 | 0.1% |
| 19118.63 | 13 | < 0.1% |
| 10556.67 | 13 | < 0.1% |
| 9883.8 | 11 | < 0.1% |
| 10535.84 | 11 | < 0.1% |
| 21114.47 | 10 | < 0.1% |
| Other values (7938) | 9170 |
| Value | Count | Frequency (%) |
| 0 | 22013 | |
| 761.69 | 1 | < 0.1% |
| 1544.01 | 1 | < 0.1% |
| 2073.39 | 1 | < 0.1% |
| 3222.72 | 1 | < 0.1% |
| 3902.74 | 1 | < 0.1% |
| 4038.52 | 1 | < 0.1% |
| 4285.2 | 1 | < 0.1% |
| 5560.61 | 1 | < 0.1% |
| 5683.68 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 231883698.8 | 1 | |
| 172734749.8 | 1 | |
| 88879567.65 | 1 | |
| 76269924.11 | 1 | |
| 59572485.76 | 1 | |
| 54304557.64 | 1 | |
| 49085033.09 | 1 | |
| 48625237.63 | 1 | |
| 43102468.91 | 1 | |
| 35024793.13 | 1 |
Transacciones
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 66 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.781338627 |
| Minimum | 0 |
|---|---|
| Maximum | 82 |
| Zeros | 12588 |
| Zeros (%) | 39.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 248.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 3 |
| 95-th percentile | 11 |
| Maximum | 82 |
| Range | 82 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 4.896140971 |
|---|---|
| Coefficient of variation (CV) | 1.760354141 |
| Kurtosis | 31.74335327 |
| Mean | 2.781338627 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 4.480378013 |
| Sum | 88263 |
| Variance | 23.97219641 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 12588 | |
| 2 | 5184 | |
| 1 | 4182 | 13.2% |
| 5 | 2013 | 6.3% |
| 3 | 1900 | 6.0% |
| 6 | 1251 | 3.9% |
| 4 | 1130 | 3.6% |
| 7 | 711 | 2.2% |
| 8 | 524 | 1.7% |
| 9 | 377 | 1.2% |
| Other values (56) | 1874 | 5.9% |
| Value | Count | Frequency (%) |
| 0 | 12588 | |
| 1 | 4182 | 13.2% |
| 2 | 5184 | |
| 3 | 1900 | 6.0% |
| 4 | 1130 | 3.6% |
| 5 | 2013 | 6.3% |
| 6 | 1251 | 3.9% |
| 7 | 711 | 2.2% |
| 8 | 524 | 1.7% |
| 9 | 377 | 1.2% |
| Value | Count | Frequency (%) |
| 82 | 1 | |
| 73 | 2 | |
| 67 | 1 | |
| 66 | 1 | |
| 63 | 2 | |
| 61 | 1 | |
| 60 | 1 | |
| 58 | 2 | |
| 57 | 1 | |
| 56 | 1 |
Transacciones Adiciones
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 60 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.87965589 |
| Minimum | 0 |
|---|---|
| Maximum | 77 |
| Zeros | 12593 |
| Zeros (%) | 39.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 248.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 7 |
| Maximum | 77 |
| Range | 77 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 3.729794485 |
|---|---|
| Coefficient of variation (CV) | 1.984296437 |
| Kurtosis | 46.48523195 |
| Mean | 1.87965589 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 5.477907699 |
| Sum | 59649 |
| Variance | 13.9113669 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 12593 | |
| 1 | 9399 | |
| 3 | 3146 | 9.9% |
| 2 | 2450 | 7.7% |
| 4 | 1151 | 3.6% |
| 5 | 655 | 2.1% |
| 6 | 450 | 1.4% |
| 7 | 315 | 1.0% |
| 8 | 253 | 0.8% |
| 9 | 183 | 0.6% |
| Other values (50) | 1139 | 3.6% |
| Value | Count | Frequency (%) |
| 0 | 12593 | |
| 1 | 9399 | |
| 2 | 2450 | 7.7% |
| 3 | 3146 | 9.9% |
| 4 | 1151 | 3.6% |
| 5 | 655 | 2.1% |
| 6 | 450 | 1.4% |
| 7 | 315 | 1.0% |
| 8 | 253 | 0.8% |
| 9 | 183 | 0.6% |
| Value | Count | Frequency (%) |
| 77 | 1 | |
| 61 | 1 | |
| 59 | 1 | |
| 57 | 1 | |
| 56 | 1 | |
| 55 | 1 | |
| 54 | 1 | |
| 53 | 1 | |
| 52 | 1 | |
| 51 | 1 |
Transacciones Retiros
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 29 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.9016827378 |
| Minimum | 0 |
|---|---|
| Maximum | 35 |
| Zeros | 18546 |
| Zeros (%) | 58.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 248.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 4 |
| Maximum | 35 |
| Range | 35 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.645622084 |
|---|---|
| Coefficient of variation (CV) | 1.825056658 |
| Kurtosis | 37.82531476 |
| Mean | 0.9016827378 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.361102423 |
| Sum | 28614 |
| Variance | 2.708072043 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 18546 | |
| 1 | 6306 | 19.9% |
| 2 | 3310 | 10.4% |
| 3 | 1855 | 5.8% |
| 4 | 725 | 2.3% |
| 5 | 347 | 1.1% |
| 6 | 249 | 0.8% |
| 8 | 104 | 0.3% |
| 7 | 83 | 0.3% |
| 9 | 56 | 0.2% |
| Other values (19) | 153 | 0.5% |
| Value | Count | Frequency (%) |
| 0 | 18546 | |
| 1 | 6306 | 19.9% |
| 2 | 3310 | 10.4% |
| 3 | 1855 | 5.8% |
| 4 | 725 | 2.3% |
| 5 | 347 | 1.1% |
| 6 | 249 | 0.8% |
| 7 | 83 | 0.3% |
| 8 | 104 | 0.3% |
| 9 | 56 | 0.2% |
| Value | Count | Frequency (%) |
| 35 | 1 | |
| 34 | 1 | |
| 27 | 1 | |
| 26 | 1 | |
| 25 | 1 | |
| 23 | 1 | |
| 22 | 2 | |
| 21 | 2 | |
| 20 | 2 | |
| 19 | 2 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 248.0 KiB |
| 1 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 31734 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 31734 |
Length
Pie chart
| Value | Count | Frequency (%) |
| 1 | 31734 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 31734 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 31734 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 31734 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 31734 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 31734 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 31734 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 31734 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| Fecha Registro | Id Modificado | Tipo Cliente | Primer Nombre | Perfil Riesgo | Riesgo | Codigo CIIU | CIIU | Fecha de Nacimiento | Cod_Ciudad_Nac. | Ciudad | Cod Dpto.Nacimto. | Departamento | Cod. Ocupacion | Ocupacion | Ingresos_mensuales | Egresos_mensuales | Otros_Ing_Mensuales | Total_Activos | Total_Pasivos | Saldo | Transacciones | Transacciones Adiciones | Transacciones Retiros | cant | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2017-08-24 | 1 | Ualet puro | DANIEL | 1 | Valiente | 10 | Medio | 1991-11-12 | 11001.0 | BOGOTA D.C. | 11 | BOGOTA | 2 | EMPLEADO | 5300000 | 1500000 | 0 | 340000000 | 40000000 | 0.00 | 8 | 6 | 2 | 1 |
| 1 | 2017-08-24 | 2 | Ualet puro | JESSICA | 3 | Estratega | 112 | Alto | 1992-05-25 | 11001.0 | BOGOTA D.C. | 11 | BOGOTA | 3 | ESTUDIANTE | 2588888 | 555558 | 888888 | 0 | 0 | 0.00 | 2 | 1 | 1 | 1 |
| 2 | 2017-08-24 | 3 | Ualet puro | DAVID | 2 | Aventurero | 7210 | Sin Clasificar | 1995-06-22 | 11001.0 | BOGOTA D.C. | 11 | BOGOTA | 2 | EMPLEADO | 737000 | 650000 | 0 | 120000000 | 7000000 | 0.00 | 0 | 0 | 0 | 1 |
| 3 | 2017-08-24 | 4 | Ualet puro | DIEGO | 2 | Aventurero | 1 | Alto | 1988-05-01 | 11001.0 | BOGOTA D.C. | 11 | BOGOTA | 2 | EMPLEADO | 5134000 | 4800000 | 0 | 100000000 | 80000000 | 0.00 | 0 | 0 | 0 | 1 |
| 4 | 2017-08-24 | 5 | Ualet puro | NICOLÁS | 1 | Valiente | 1 | Alto | 1995-05-05 | 11001.0 | BOGOTA D.C. | 11 | BOGOTA | 3 | ESTUDIANTE | 700000 | 0 | 100000 | 0 | 0 | 0.00 | 6 | 5 | 1 | 1 |
| 5 | 2017-08-24 | 6 | Ualet puro | JUAN | 1 | Valiente | 1 | Alto | 1992-08-13 | 6183.0 | Sin ciudad | 5 | ANTIOQUIA | 2 | EMPLEADO | 5000000 | 3000000 | 0 | 100000000 | 2000000 | 0.00 | 4 | 3 | 1 | 1 |
| 6 | 2017-08-24 | 7 | Ualet puro | DIANA | 2 | Aventurero | 1 | Alto | 1986-03-28 | 6249.0 | Sin ciudad | 8 | ATLANTICO | 2 | EMPLEADO | 14500000 | 9000000 | 0 | 100000000 | 15000000 | 64740.47 | 8 | 6 | 2 | 1 |
| 7 | 2017-08-24 | 8 | Ualet puro | CAMILO | 1 | Valiente | 1 | Alto | 1991-04-02 | 7182.0 | Sin ciudad | 76 | VALLE DEL CAUCA | 1 | INDEPENDIENTE | 12000000 | 3000000 | 0 | 196035000 | 51936000 | 0.00 | 2 | 1 | 1 | 1 |
| 8 | 2017-08-24 | 9 | Ualet puro | OMAR | 4 | Planeador | 0 | Bajo | 1963-10-06 | 73283.0 | FRESNO | 73 | TOLIMA | 0 | Codigo no esta Creado | 0 | 0 | 0 | 0 | 0 | 3199917.17 | 35 | 29 | 6 | 1 |
| 9 | 2017-08-24 | 10 | Ualet puro | CELSO | 4 | Planeador | 10 | Medio | 1964-01-12 | 6705.0 | Sin ciudad | 25 | CUNDINAMARCA | 2 | EMPLEADO | 19000000 | 10000000 | 0 | 600000000 | 200000000 | 1136146.43 | 9 | 7 | 2 | 1 |
Last rows
| Fecha Registro | Id Modificado | Tipo Cliente | Primer Nombre | Perfil Riesgo | Riesgo | Codigo CIIU | CIIU | Fecha de Nacimiento | Cod_Ciudad_Nac. | Ciudad | Cod Dpto.Nacimto. | Departamento | Cod. Ocupacion | Ocupacion | Ingresos_mensuales | Egresos_mensuales | Otros_Ing_Mensuales | Total_Activos | Total_Pasivos | Saldo | Transacciones | Transacciones Adiciones | Transacciones Retiros | cant | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 31724 | 2021-03-25 | 31845 | Ualet puro | NATALIA | 4 | Planeador | 0 | Bajo | 1978-12-05 | 36576.0 | Sin ciudad | 11 | BOGOTA | 0 | Codigo no esta Creado | 0 | 0 | 0 | 0 | 0 | 0.0 | 0 | 0 | 0 | 1 |
| 31725 | 2021-03-25 | 31846 | Ualet puro | JONATAN | 3 | Estratega | 0 | Bajo | 1993-01-17 | 30789.0 | Sin ciudad | 11 | BOGOTA | 0 | Codigo no esta Creado | 0 | 0 | 0 | 0 | 0 | 0.0 | 0 | 0 | 0 | 1 |
| 31726 | 2021-03-25 | 31847 | Ualet puro | IVAN | 3 | Estratega | 0 | Bajo | 1986-05-27 | 32767.0 | Sin ciudad | 11 | BOGOTA | 0 | Codigo no esta Creado | 0 | 0 | 0 | 0 | 0 | 0.0 | 0 | 0 | 0 | 1 |
| 31727 | 2021-03-25 | 31848 | Ualet puro | DAVID | 4 | Planeador | 0 | Bajo | 1978-11-02 | 36494.0 | Sin ciudad | 15 | BOYACA | 0 | Codigo no esta Creado | 0 | 0 | 0 | 0 | 0 | 0.0 | 0 | 0 | 0 | 1 |
| 31728 | 2021-03-25 | 31849 | Ualet puro | ANGIE | 3 | Estratega | 0 | Bajo | 1996-03-10 | 36522.0 | Sin ciudad | 15 | BOYACA | 0 | Codigo no esta Creado | 0 | 0 | 0 | 0 | 0 | 0.0 | 0 | 0 | 0 | 1 |
| 31729 | 2021-03-25 | 31850 | Ualet puro | DIEGO | 4 | Planeador | 0 | Bajo | 2000-03-16 | 33611.0 | Sin ciudad | 11 | BOGOTA | 0 | Codigo no esta Creado | 0 | 0 | 0 | 0 | 0 | 0.0 | 0 | 0 | 0 | 1 |
| 31730 | 2021-03-25 | 31851 | Ualet puro | DIEGO | 4 | Planeador | 0 | Bajo | 1976-05-05 | 24162.0 | Sin ciudad | 13 | BOLIVAR | 0 | Codigo no esta Creado | 0 | 0 | 0 | 0 | 0 | 0.0 | 0 | 0 | 0 | 1 |
| 31731 | 2021-03-25 | 31852 | Ualet puro | BRANDON | 4 | Planeador | 0 | Bajo | 1955-03-20 | 35629.0 | Sin ciudad | 11 | BOGOTA | 0 | Codigo no esta Creado | 0 | 0 | 0 | 0 | 0 | 0.0 | 0 | 0 | 0 | 1 |
| 31732 | 2021-03-25 | 31853 | Ualet puro | SANTIAGO | 4 | Planeador | 0 | Bajo | 1991-12-14 | 36470.0 | Sin ciudad | 68 | SANTANDER | 0 | Codigo no esta Creado | 0 | 0 | 0 | 0 | 0 | 0.0 | 0 | 0 | 0 | 1 |
| 31733 | 2021-03-25 | 31854 | Ualet puro | CARLOS | 4 | Planeador | 0 | Bajo | 1995-08-25 | 34913.0 | Sin ciudad | 5 | ANTIOQUIA | 0 | Codigo no esta Creado | 0 | 0 | 0 | 0 | 0 | 0.0 | 0 | 0 | 0 | 1 |